Delete in MySQL DB table

Let’s see how we can Delete in MySQL DB table using the DB connector in MuleSoft.

Create a project in Anypoint Studio

Add the HTTP listener and flow to get request for delete

Drag and Drop Delete activity in a flow

Create a MySQL connection by following the steps mentioned in Connect with MySQL DB through MuleSoft

Add the delete statement and input parameter

Set the response payload

Run the service

Test the endpoint in SOAP UI

We can see the record is updated in the table

Before

After Deletion

Sample Application – mysql-db-service

Sample SOAP UI project – MySQL-service-soapui-project